﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using SQLExecute;

/// <summary>
/// Summary description for Skills_And_Qualifications
/// </summary>
public class Skills_And_Qualifications:Profiles
{
    private string _degree_type;
    private string _disciplines;
    private string _english_skills;
    private string _other_language;

    private string _info_degree_date1;
    private string _info_degree_date2;
    private string _info_degree_date3;
    private string _info_degree_date4;


    public string DegreeType
    {
        set { _degree_type = value; }
        get { return _degree_type; }
    }
    public string Disciplines
    {
        set { _disciplines = value; }
        get { return _disciplines; }
    }
    public string EnglishSkills
    {
        set { _english_skills = value; }
        get { return _english_skills; }
    }
    public string OtherLanguage
    {
        set { _other_language = value; }
        get { return _other_language; }
    }

    private string _computer_skills;
    private string _other_skills;
    private string _info_degree1;
    private string _info_degree2;
    private string _info_degree3;
    private string _info_degree4;
    public string ComputerSkills
    {
        set { _computer_skills = value; }
        get { return _computer_skills; }
    }
    public string OtherSkills
    {
        set { _other_skills = value; }
        get { return _other_skills; }
    }

    public string InfoDegree1
    {
        set { _info_degree1 = value; }
        get { return _info_degree1; }
    }
    public string InfoDegree2
    {
        set { _info_degree2 = value; }
        get { return _info_degree2; }
    }
    public string InfoDegree3
    {
        set { _info_degree3 = value; }
        get { return _info_degree3; }
    }
    public string InfoDegree4
    {
        set { _info_degree4 = value; }
        get { return _info_degree4; }
    }

    public string Info_Degree_Date1
    {
        set { _info_degree_date1 = value; }
        get { return _info_degree_date1; }
    }
    public string Info_Degree_Date2
    {
        set { _info_degree_date2 = value; }
        get { return _info_degree_date2; }
    }
    public string Info_Degree_Date3
    {
        set { _info_degree_date3 = value; }
        get { return _info_degree_date3; }
    }
    public string Info_Degree_Date4
    {
        set { _info_degree_date4 = value; }
        get { return _info_degree_date4; }
    }

    private int _major1, _major2, _major3, _major4;
    public int Major1
    {
        set { _major1 = value; }
        get { return _major1; }
    }
    public int Major2
    {
        set { _major2 = value; }
        get { return _major2; }
    }
    public int Major3
    {
        set { _major3 = value; }
        get { return _major3; }
    }
    public int Major4
    {
        set { _major4 = value; }
        get { return _major4; }
    }


    private string _majorname1, _majorname2, _majorname3, _majorname4;
    public string MajorName1
    {
        set { _majorname1 = value; }
        get { return _majorname1; }
    }
    public string MajorName2
    {
        set { _majorname2 = value; }
        get { return _majorname2; }
    }
    public string MajorName3
    {
        set { _majorname3 = value; }
        get { return _majorname3; }
    }
    public string MajorName4
    {
        set { _majorname4 = value; }
        get { return _majorname4; }
    }
    


    private string _school1, _school2, _school3, _school4;
    public string School1
    {
        set { _school1 = value; }
        get { return _school1; }
    }
    public string School2
    {
        set { _school2 = value; }
        get { return _school2; }
    }
    public string School3
    {
        set { _school3 = value; }
        get { return _school3; }
    }
    public string School4
    {
        set { _school4 = value; }
        get { return _school4; }
    }

    private string _typetraining1, _typetraining2, _typetraining3, _typetraining4;
    public string Typetraining1
    {
        set { _typetraining1 = value; }
        get { return _typetraining1; }
    }
    public string Typetraining2
    {
        set { _typetraining2 = value; }
        get { return _typetraining2; }
    }
    public string Typetraining3
    {
        set { _typetraining3 = value; }
        get { return _typetraining3; }
    }
    public string Typetraining4
    {
        set { _typetraining4 = value; }
        get { return _typetraining4; }
    }
    private string _skillsnote;
    

    public string SkillsNote
    {
        set { _skillsnote = value; }
        get { return _skillsnote; }
    }
	public Skills_And_Qualifications()
	{
		//
		// TODO: Add constructor logic here
		//
	}
    public Skills_And_Qualifications(int id
                                    ,string highest_degree
                                    ,string info_degree1
                                    ,string info_degree2
                                    ,string info_degree3
                                    ,string info_degree4
                                    ,int major1
                                    ,int major2
                                    ,int major3
                                    
                                    )
    {
        
    }
    public void Insert_Skills_Qualifications()
    {

        SqlHelper.ExecuteNonQuery(Common.strConnect, "Insert_Skills_Qualifications", new object[]
                                  {this._id
                                   ,this._degree_type
                                   ,this._info_degree1
                                   ,this._info_degree2
                                   ,this._info_degree3
                                   ,this._info_degree4
                                   ,this._major1
                                   ,this._major2
                                   ,this._major3
                                   ,this._major4
                                   ,this._school1
                                   ,this._school2
                                   ,this._school3
                                   ,this._school4
                                   ,this._typetraining1
                                   ,this._typetraining2
                                   ,this._typetraining3
                                   ,this._typetraining4
                                   ,this._info_degree_date1
                                   ,this._info_degree_date2
                                   ,this._info_degree_date3
                                   ,this._info_degree_date4
                                   ,this._english_skills
                                   ,this._other_language
                                   ,this._computer_skills
                                   ,this._other_skills
                                        
                                  });
    }
    public void Insert_Skills_Qualifications2()
    {

        SqlHelper.ExecuteNonQuery(Common.strConnect, "Insert_Skills_Qualifications2", new object[]
                                  {this._id
                                   ,this._degree_type
                                   ,this._info_degree1
                                   ,this._info_degree2
                                   ,this._info_degree3
                                   ,this._info_degree4
                                   ,this._majorname1
                                   ,this._majorname2
                                   ,this._majorname3
                                   ,this._majorname4
                                   ,this._school1
                                   ,this._school2
                                   ,this._school3
                                   ,this._school4
                                   ,this._typetraining1
                                   ,this._typetraining2
                                   ,this._typetraining3
                                   ,this._typetraining4
                                   ,this._info_degree_date1
                                   ,this._info_degree_date2
                                   ,this._info_degree_date3
                                   ,this._info_degree_date4
                                   ,this._english_skills
                                   ,this._other_language
                                   ,this._computer_skills
                                   ,this._other_skills
                                        
                                  });
    }
    public void Update_Skills_Qualifications()
    {

        SqlHelper.ExecuteNonQuery(Common.strConnect, "Update_Skills_Qualifications", new object[]
                                  {this._id, this._degree_type
                                   ,this._info_degree1,this._info_degree2,this._info_degree3,this._info_degree4
                                   ,this._major1,this._major2,this._major3,this._major4
                                   ,this._school1,this._school2,this._school3,this._school4
                                   ,this._typetraining1,this._typetraining2,this._typetraining3,this._typetraining4
                                   ,this._info_degree_date1,this._info_degree_date2,this._info_degree_date3,this._info_degree_date4
                                   ,this._english_skills,this._other_language,this._computer_skills,this._other_skills
                                   ,this._skillsnote     
                                  });
    }

    public void Update_Skills_Qualifications2()
    {

        SqlHelper.ExecuteNonQuery(Common.strConnect, "Update_Skills_Qualifications2", new object[]
                                  {this._id, this._degree_type
                                   ,this._info_degree1,this._info_degree2,this._info_degree3,this._info_degree4
                                   ,this._majorname1,this._majorname2,this._majorname3,this._majorname4
                                   ,this._school1,this._school2,this._school3,this._school4
                                   ,this._typetraining1,this._typetraining2,this._typetraining3,this._typetraining4
                                   ,this._info_degree_date1,this._info_degree_date2,this._info_degree_date3,this._info_degree_date4
                                   ,this._english_skills,this._other_language,this._computer_skills,this._other_skills
                                   ,this._skillsnote     
                                  });
    }
}
